{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["7R","8R","8RT","7R Option Weights","8R Option Weights","8RT Option Weights"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":1,"defined_names":245,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"7R","index":0,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[[7,2,7,4],[8,2,8,4],[13,2,13,4],[14,2,14,4],[18,8,18,10],[18,4,18,6],[19,8,19,10],[25,2,27,2],[25,4,25,6],[25,8,25,10],[30,2,33,2],[31,4,31,10],[19,4,19,6],[20,4,20,6],[21,4,21,6],[23,4,23,6],[22,4,22,6]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Type your name:",null,null,null,"Model:",null,"Transmission:",null,"Front axle:"]
[null,null,null,null,null,null,"7210R",null,"CommandQuad",null,"1150 MFWD"]
[null,null,null,null,null,null,{"$f":"INDEX(model_7_w,MATCH(G9,model_7,0))","v":0},null,{"$f":"INDEX(tran_7_w,MATCH(I9,tran_7,0))","v":0},null,{"$f":"INDEX(FA_7_w,MATCH(K9,FA_7,0))","v":7358}]
[null,null,null,null,null,null,{"$f":"INDEX(model_7_s,MATCH(G9,model_7,0))","v":0.39700000000000002},null,{"$f":"INDEX(tran_7_s,MATCH(I9,tran_7,0))","v":0.4},null,{"$f":"INDEX(FA_7_s,MATCH(K9,FA_7,0))","v":0.39}]
[null,null,null,null,null,null,{"$f":"INDEX(hp_7,MATCH(G9,model_7,0))","v":210}]
[]
[null,null,"Name of analysis:",null,null,null,"Front hitch:",null,"Front PTO:",null,"Fuel level:"]
[null,null,"",null,null,null,"Not Included",null,"Not Included",null,"Half"]
[null,null,null,null,null,null,{"$f":"INDEX(hitch_7_w,MATCH(G15,hitch_7,0))","v":0},null,{"$f":"INDEX(PTO_7_w,MATCH(I15,PTO_7,0))","v":0},null,{"$f":"IF(I9=\"IVT\",INDEX(fuel_7_w_IVT,MATCH(K15,fuel_7,0)),IF(I9=\"e23\",INDEX(fuel_7_w_e23,MATCH(K15,fuel_7,0)),INDEX(fuel_7_w,MATCH(K15,fuel_7,0))))","v":227.71725000000001}]
[null,null,null,null,null,null,{"$f":"INDEX(hitch_7_s,MATCH(G15,hitch_7,0))","v":1},null,{"$f":"INDEX(PTO_7_s,MATCH(I15,PTO_7,0))","v":1.2010000000000001},null,{"$f":"INDEX(fuel_7_s,MATCH(K15,fuel_7,0))","v":0.44890000000000002}]
[]
[null,null,null,null,"Front wheels & tires",null,null,null,"Rear wheels & tires"]
[null,null,null,null,"Group 42",null,null,null,"Group 47"]
[null,null,null,null,"Single:",null,null,null,"Single:",null,"Dual:"]
[null,null,null,null,"420/90R30",null,null,null,"480/80R46",null,"480/80R46"]
[null,null,null,null,{"$f":"IF(E20=\"Group 42\",INDEX(G42_7_w,MATCH(E22,G42_7,0)),IF(E20=\"Group 43\", INDEX(G43_7_w,MATCH(E22,G43_7,0)),IF(E20=\"Group 44\",INDEX(G44_7_w,MATCH(E22,G44_7,0)),0)))","v":354},null,null,null,{"$f":"IF(I20=\"Group 47\",INDEX(G47_1_7_w,MATCH(I22,G47_1_7,0)),IF(I20=\"Group 48\", INDEX(G48_1_7_w,MATCH(I22,G48_1_7,0)),IF(I20=\"Group 49\",INDEX(G49_1_7_w,MATCH(I22,G49_1_7,0)),0)))","v":1004},null,{"$f":"IF(I20=\"Group 47\",INDEX(G47_2_7_w,MATCH(K22,G47_2_7,0)),IF(I20=\"Group 48\", INDEX(G48_2_7_w,MATCH(K22,G48_2_7,0)),IF(I20=\"Group 49\",INDEX(G49_2_7_w,MATCH(K22,G49_2_7,0)),0)))","v":880}]
[null,null,null,null,1,null,null,null,0,null,0]
[]
[null,null,"Choose a ballast package code -OR- build a custom package with the options to the right ",null,"Front ballast",null,null,null,"Enter any additional ballast"]
[null,null,null,null,"Weight support:",null,"Suitcase weights:",null,"Front (kg):",null,"Rear (kg):"]
[null,null,1,null,"Not Included",null,"None",null,0,null,0]
[null,null,1,null,{"$f":"INDEX(FWS_7_w,MATCH(E28,FWS_7,0))","v":0},null,{"$f":"INDEX(SW_7_w,MATCH(G28,SW_7,0))","v":0},null,{"$f":"I28","v":0},null,{"$f":"K28","v":0}]
[null,null,null,null,{"$f":"INDEX(FWS_7_s,MATCH(E28,FWS_7,0))","v":1.3443000000000001},null,{"$f":"INDEX(SW_7_s,MATCH(G28,SW_7,0))","v":1.4359},null,1,null,0]
[]
[null,null,null,null,"Rear wheel weights"]
[null,null,null,null,"72 kg:",null,"205 kg:",null,"625 kg:",null,"970 kg:"]
[null,null,null,null,"None",null,"None",null,"None",null,"None"]
[null,null,null,null,{"$f":"INDEX(w72_8_w,MATCH(E34,w72_8,0))","v":0},null,{"$f":"INDEX(w205_8_w,MATCH(G34,w205_8,0))","v":0},null,{"$f":"INDEX(w625_8_w,MATCH(I34,w625_8,0))","v":0},null,{"$f":"INDEX(w970_8_w,MATCH(K34,w970_8,0))","v":0}]
[null,null,null,null,0,null,0,null,0,null,0]
[]
[]
[null,null,"Total weight:",null,{"$f":"C48& \" kg       \"&ROUND(C48*2.20462,1)& \" lb\"","v":"9824 kg       21658.2 lb"}]
[null,null,"Weight / PTO-hp (SAE):",null,{"$f":"ROUND(C48/I48,0)& \" kg/PTO-hp   \"& ROUND((C48*2.20462)/I48,0) &\" lb/PTO-hp\"","v":"58 kg/PTO-hp   127 lb/PTO-hp"}]
[null,null,"Weight / Engine power:",null,{"$f":"ROUND(C48/G12,0)& \" kg/hp          \"& ROUND((C48*2.20462)/G12,0) &\" lb/hp\"","v":"47 kg/hp          103 lb/hp"}]
[null,null,"Front axle weight:",null,{"$f":"E48&\" kg           \"&ROUND(E48*2.20462,0)& \" lb\"","v":"3326 kg           7333 lb"}]
[null,null,"Rear axle weight:",null,{"$f":"C48-E48&\" kg           \"&ROUND((C48-E48)*2.20462,0)& \" lb\"","v":"6498 kg           14326 lb"},null,{"$f":"G48","v":0.33900000000000002},null,{"$f":"100%-G43","v":0.66100000000000003},null,{"$f":"TODAY()","v":"2016-05-26"}]
[]
[]
[]
[]
[null,null,{"$f":"ROUND(SUM(G10,I10,K10,G16,I16,K16,E23,I23,K23,E29,G29,I29,K29,E35,G35,I35,K35),0)","v":9824},null,{"$f":"ROUND(SUM(G10*G11,I10*I11,K10*K11,G16*G17,I16*I17,K16*K17,E23*E24,I23*I24,K23*K24,E29*E30,G29*G30,I29*I30,K29*K30,E35*E36,G35*G36,I35*I36,K35*K36),0)","v":3326},null,{"$f":"ROUND(E48/C48,3)","v":0.33900000000000002},null,{"$f":"INDEX(PTOhp_7,MATCH(G9,model_7,0))","v":170}]

{"sheet":"8R","index":1,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[30,2,33,2],[31,4,31,10],[7,2,7,4],[8,2,8,4],[13,2,13,4],[14,2,14,4],[18,2,18,4],[18,6,18,10],[19,2,19,4],[19,6,19,10],[25,2,27,2],[25,4,25,6],[25,8,25,10]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Type your name:",null,null,null,"Model:",null,"Transmission:",null,"Front axle:"]
[null,null,null,null,null,null,"8245R",null,"16 PST",null,"1300 MFWD"]
[null,null,null,null,null,null,{"$f":"IF(K9=\"ILS\",INDEX(model_8_w_ILS,MATCH(G9,model_8,0)),INDEX(model_8_w,MATCH(G9,model_8,0)))","v":0},null,{"$f":"IF(K9=\"ILS\",INDEX(tran_8_w_ILS,MATCH(I9,tran_8,0)),IF(K9=\"1500 MFWD\",INDEX(tran_8_w_1500,MATCH(I9,tran_8,0)),INDEX(tran_8_w,MATCH(I9,tran_8,0))))","v":303.18},null,{"$f":"INDEX(FA_8_w,MATCH(K9,FA_8,0))","v":8727.48}]
[null,null,null,null,null,null,{"$f":"INDEX(model_8_s,MATCH(G9,model_8,0))","v":0.47799999999999998},null,{"$f":"INDEX(tran_8_s,MATCH(I9,tran_8,0))","v":0.47399999999999998},null,{"$f":"IF(I9=\"e23\",INDEX(FA_8_s_e23,MATCH(K9,FA_8,0)),IF(I9=\"IVT\",INDEX(FA_8_s_IVT,MATCH(K9,FA_8,0)),(INDEX(FA_8_s,MATCH(K9,FA_8,0)))))","v":0.44900000000000001}]
[null,null,null,null,null,null,{"$f":"INDEX(hp_8,MATCH(G9,model_8,0))","v":245}]
[]
[null,null,"Name of analysis:",null,null,null,"Front hitch:",null,"Front PTO:",null,"Fuel level:"]
[null,null,"",null,null,null,"Not Included",null,"Not Included",null,"Half"]
[null,null,null,null,null,null,{"$f":"INDEX(hitch_8_w,MATCH(G15,hitch_8,0))","v":0},null,{"$f":"INDEX(PTO_8_w,MATCH(I15,PTO_8,0))","v":0},null,{"$f":"IF(G20=\"Group 49\",INDEX(fuel_8_w_G49,MATCH(K15,fuel_8,0)),INDEX(fuel_8_w,MATCH(K15,fuel_8,0)))","v":288.06725}]
[null,null,null,null,null,null,{"$f":"INDEX(hitch_8_s,MATCH(G15,hitch_8,0))","v":1.4845999999999999},null,{"$f":"INDEX(PTO_8_s,MATCH(I15,PTO_8,0))","v":1.4754},null,{"$f":"INDEX(fuel_8_s,MATCH(K15,fuel_8,0))","v":0.39}]
[]
[null,null,"Front wheels & tires",null,null,null,"Rear wheels & tires"]
[null,null,"Group 42",null,null,null,"Group 47"]
[null,null,"Single:",null,"Dual:",null,"Single:",null,"Dual:",null,"Triple:"]
[null,null,"420/90R30",null,"None",null,"480/80R46",null,"480/80R46",null,"None"]
[null,null,{"$f":"IF(C20=\"Group 42\",INDEX(G42_1_w,MATCH(C22,G42_1,0)),IF(C20=\"Group 43\", INDEX(G43_1_w,MATCH(C22,G43_1,0)),IF(C20=\"Group 44\",INDEX(G44_1_w,MATCH(C22,G44_1,0)),0)))","v":354},null,{"$f":"IF(C20=\"Group 42\",INDEX(G42_2_w,MATCH(E22,G42_2,0)),IF(C20=\"Group 43\", INDEX(G43_2_w,MATCH(E22,G43_2,0)),IF(C20=\"Group 44\",INDEX(G44_2_w,MATCH(E22,G44_2,0)),0)))","v":0},null,{"$f":"IF(G20=\"Group 47\",INDEX(G47_1_w,MATCH(G22,G47_1,0)),IF(G20=\"Group 48\", INDEX(G48_1_w,MATCH(G22,G48_1,0)),IF(G20=\"Group 49\",INDEX(G49_1_w,MATCH(G22,G49_1,0)),0)))","v":1004},null,{"$f":"IF(G20=\"Group 47\",INDEX(G47_2_w,MATCH(I22,G47_2,0)),IF(G20=\"Group 48\", INDEX(G48_2_w,MATCH(I22,G48_2,0)),IF(G20=\"Group 49\",INDEX(G49_2_w,MATCH(I22,G49_2,0)),0)))","v":880},null,{"$f":"IF(G20=\"Group 47\",INDEX(G47_3_w,MATCH(K22,G47_3,0)),IF(G20=\"Group 48\", INDEX(G48_3_w,MATCH(K22,G48_3,0)),IF(G20=\"Group 49\",INDEX(G49_3_w,MATCH(K22,G49_3,0)),0)))","v":0}]
[null,null,1,null,1,null,0,null,0,null,0]
[]
[null,null,"Choose a ballast package code -OR- build a custom package with the options to the right ",null,"Front ballast",null,null,null,"Enter any additional ballast"]
[null,null,null,null,"Weight support:",null,"Suitcase weights:",null,"Front (kg):",null,"Rear (kg):"]
[null,null,1,null,"Not Included",null,"None",null,0,null,0]
[null,null,1,null,{"$f":"INDEX(FWS_8_w,MATCH(E28,FWS_8,0))","v":0},null,{"$f":"INDEX(SW_8_w,MATCH(G28,SW_8,0))","v":0},null,{"$f":"I28","v":0},null,{"$f":"K28","v":0}]
[null,null,null,null,{"$f":"INDEX(FWS_8_s,MATCH(E28,FWS_8,0))","v":1.4701500000000001},null,{"$f":"INDEX(SW_8_s,MATCH(G28,SW_8,0))","v":1.5629999999999999},null,1,null,0]
[]
[null,null,null,null,"Rear wheel weights"]
[null,null,null,null,"72 kg:",null,"205 kg:",null,"625 kg:",null,"970 kg:"]
[null,null,null,null,"None",null,"None",null,"None",null,"None"]
[null,null,null,null,{"$f":"INDEX(w72_8_w,MATCH(E34,w72_8,0))","v":0},null,{"$f":"INDEX(w205_8_w,MATCH(G34,w205_8,0))","v":0},null,{"$f":"INDEX(w625_8_w,MATCH(I34,w625_8,0))","v":0},null,{"$f":"INDEX(w970_8_w,MATCH(K34,w970_8,0))","v":0}]
[null,null,null,null,0,null,0,null,0,null,0]
[]
[]
[null,null,"Total weight:",null,{"$f":"C47& \" kg       \"&ROUND(C47*2.20462,0)& \" lb\"","v":"11557 kg       25479 lb"}]
[null,null,"Weight / PTO-hp (SAE):",null,{"$f":"ROUND(C47/I47,0)& \" kg/PTO-hp   \"& ROUND((C47*2.20462)/I47,0) &\" lb/PTO-hp\"","v":"58 kg/PTO-hp   127 lb/PTO-hp"}]
[null,null,"Weight / Engine power:",null,{"$f":"ROUND(C47/G12,0)& \" kg/hp          \"& ROUND((C47*2.20462)/G12,0) &\" lb/hp\"","v":"47 kg/hp          104 lb/hp"}]
[null,null,"Front axle weight:",null,{"$f":"E47&\" kg           \"&ROUND(E47*2.20462,0)& \" lb\"","v":"4529 kg           9985 lb"}]
[null,null,"Rear axle weight:",null,{"$f":"C47-E47&\" kg           \"&ROUND((C47-E47)*2.20462,0)& \" lb\"","v":"7028 kg           15494 lb"},null,{"$f":"G47","v":0.39200000000000002},null,{"$f":"100%-G43","v":0.60799999999999998},null,{"$f":"TODAY()","v":"2016-05-26"}]
[]
[]
[]
[null,null,{"$f":"ROUND(SUM(G10,I10,K10,G16,I16,K16,C23,E23,G23,I23,K23,E29,G29,I29,K29,E35,G35,I35,K35),0)","v":11557},null,{"$f":"ROUND(SUM(G10*G11,I10*I11,K10*K11,G16*G17,I16*I17,K16*K17,C23*C24,E23*E24,G23*G24,I23*I24,K23*K24,E29*E30,G29*G30,I29*I30,K29*K30,E35*E36,G35*G36,I35*I36,K35*K36),0)","v":4529},null,{"$f":"ROUND(E47/C47,3)","v":0.39200000000000002},null,{"$f":"INDEX(PTOhp_8,MATCH(G9,model_8,0))","v":200}]

{"sheet":"8RT","index":2,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[24,8,24,10],[18,2,18,10],[7,2,7,4],[8,2,8,4],[13,2,13,4],[14,2,14,4]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Type your name:",null,null,null,"Model:",null,"Transmission:",null,"Rear axle:"]
[null,null,null,null,null,null,"8370RT",null,"IVT",null,"120 in"]
[null,null,null,null,null,null,{"$f":"INDEX(model_8T_w,MATCH(G9,model_8T,0))","v":0},null,{"$f":"INDEX(tran_8T_w,MATCH(I9,tran_8T,0))","v":12752.52},null,{"$f":"INDEX(RA_8T_w,MATCH(K9,RA_8T,0))","v":918.71}]
[null,null,null,null,null,null,{"$f":"INDEX(model_8T_s,MATCH(G9,model_8T,0))","v":0},null,{"$f":"INDEX(tran_8T_s,MATCH(I9,tran_8T,0))","v":0.72},null,0]
[null,null,null,null,null,null,{"$f":"INDEX(hp_8T,MATCH(G9,model_8T,0))","v":370}]
[]
[null,null,"Name of analysis:",null,null,null,"Rear drive wheels:",null,"Tracks:",null,"Fuel level:"]
[null,null,"",null,null,null,"Wide",null,"25 in, 6500 Series",null,"Half"]
[null,null,null,null,null,null,{"$f":"INDEX(rdw_8T_w,MATCH(G15,rdw_8T,0))","v":1259.73},null,{"$f":"INDEX(tracks_8T_w,MATCH(I15,tracks_8T,0))","v":1252},null,{"$f":"INDEX(fuel_8T_w,MATCH(K15,fuel_8T,0))","v":337.34}]
[null,null,null,null,null,null,0,null,{"$f":"INDEX(tracks_8T_s,MATCH(I15,tracks_8T,0))","v":0.5},null,{"$f":"INDEX(fuel_8T_s,MATCH(K15,fuel_8T,0))","v":0.47499999999999998}]
[]
[null,null,"Front ballast"]
[null,null,"Weight support:",null,"Suitcase weights:",null,"36-kg idler:",null,"72-kg idler:",null,"205-kg idler:"]
[null,null,"Not Included",null,"None",null,"None",null,"None",null,"None"]
[null,null,{"$f":"INDEX(FWS_8T_w,MATCH(C21,FWS_8T,0))","v":0},null,{"$f":"INDEX(SW_8T_w,MATCH(E21,SW_8T,0))","v":0},null,{"$f":"INDEX(w36_8T_w,MATCH(G21,w36_8T,0))","v":0},null,{"$f":"INDEX(w72_8T_w,MATCH(I21,w72_8T,0))","v":0},null,{"$f":"INDEX(w205_8T_w,MATCH(K21,w205_8T,0))","v":0}]
[null,null,{"$f":"INDEX(FWS_8T_s,MATCH(C21,FWS_8T,0))","v":1.79165},null,{"$f":"INDEX(SW_8T_s,MATCH(E21,SW_8T,0))","v":1.905},null,1,null,1,null,1]
[]
[null,null,null,null,null,null,null,null,"Enter any additional ballast"]
[null,null,null,null,null,null,null,null,"Front (kg):",null,"Rear (kg):"]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,{"$f":"I27","v":0},null,{"$f":"K27","v":0}]
[null,null,null,null,null,null,null,null,1,null,0]
[]
[]
[null,null,"Total weight:",null,{"$f":"C40& \" kg       \"&ROUND(C40*2.20462,0)& \" lb\"","v":"16520 kg       36420 lb"}]
[null,null,"Weight / PTO-hp (SAE):",null,{"$f":"ROUND(C40/I40,0)& \" kg/PTO-hp   \"& ROUND((C40*2.20462)/I40,0) &\" lb/PTO-hp\"","v":"54 kg/PTO-hp   118 lb/PTO-hp"}]
[null,null,"Weight / Engine power:",null,{"$f":"ROUND(C40/G12,0)& \" kg/hp          \"& ROUND((C40*2.20462)/G12,0) &\" lb/hp\"","v":"45 kg/hp          98 lb/hp"}]
[null,null,"Front axle weight:",null,{"$f":"E40&\" kg          \"&ROUND(E40*2.20462,0)& \" lb\"","v":"9968 kg          21976 lb"}]
[null,null,"Rear axle weight:",null,{"$f":"C40-E40&\" kg           \"&ROUND((C40-E40)*2.20462,0)& \" lb\"","v":"6552 kg           14445 lb"},null,{"$f":"G40","v":0.60299999999999998},null,{"$f":"100%-G36","v":0.39700000000000002},null,{"$f":"TODAY()","v":"2016-05-26"}]
[]
[]
[]
[null,null,{"$f":"ROUND(SUM(G10,I10,K10,G16,I16,K16,C22,E22,G22,I22,K22,I28,K28),0)","v":16520},null,{"$f":"ROUND(SUM(G10*G11,I10*I11,K10*K11,G16*G17,I16*I17,K16*K17,C22*C23,E22*E23,G22*G23,I22*I23,K22*K23,I28*I29,K28*K29),0)","v":9968},null,{"$f":"ROUND(E40/C40,3)","v":0.60299999999999998},null,{"$f":"INDEX(PTOhp_8T,MATCH(G9,model_8T,0))","v":308}]

{"sheet":"7R Option Weights","index":3,"n_rows":151,"n_cols":7,"rows_kept":151,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"kg total","% front axle","compatibility "]
["Model",null,null,"engine hp","PTO hp"]
["7210R",0,0.39700000000000002,210,170]
["7230R",0,0.39700000000000002,230,189]
["7250R",261,0.39700000000000002,250,205]
["7270R",261,0.39700000000000002,270,224]
["7290R",514,0.39700000000000002,290,242]
["7310R",514,0.39700000000000002,310,260]
[]
["Transmission"]
["CommandQuad",0,0.4,"N/A on 7250R +"]
["e23",472,0.39700000000000002]
["IVT",407,0.39700000000000002]
[]
["Front Axle"]
["1150 MFWD",7358,0.39,"N/A on 7230R +"]
["1300 MFWD",7433,0.39,"N/A on 7210R"]
["TLS",7584,0.4]
["TLS w/ front brakes",7678,0.40699999999999997]
[]
["Front 3-Point Hitch"]
["Not Included",0,1]
["Standard (carrier)",479.1,1.2579]
["Premium (ground)",593.20000000000005,1.2293000000000001]
[]
["Front PTO"]
["Not Included",0,1.2010000000000001]
["Included",187.5,1.2010000000000001]
[]
["Fuel level","CQ",null,"IVT","e23",null,"Diesel + DEF"]
["Empty",0,0.44890000000000002,0,0,null,"CQ: diesel volume of 508L at .85kg/L"]
["Half",{"$f":"0.5*B35","v":227.71725000000001},0.44890000000000002,{"$f":"0.5*D35","v":239.82974999999999},{"$f":"0.5*E35","v":220.49224999999998},null,"IVT avg: diesel volume of 531.5 at .85kg/L"]
["Full",{"$f":"(503*0.85)+(25.7*1.085)","v":455.43450000000001},0.44890000000000002,{"$f":"(531.5*0.85)+(25.7*1.085)","v":479.65949999999998},{"$f":"(486*0.85)+(25.7*1.085)","v":440.98449999999997},null,"e23 avg: diesel volume of 486L at .85kg/L"]
[null,null,null,null,null,null,"def volume of 25.7 L at 1.085 kg/L"]
["Front Weight Support"]
["Not Included",0,1.3443000000000001]
["Included",124,1.3443000000000001]
[]
["Front Suitcase Weights"]
["None",0,1.4359]
[4,{"$f":"43*A43","v":172},1.4359]
[8,{"$f":"43*A44","v":344},1.4359]
[12,516,1.4359]
[16,688,1.4359]
[20,{"$f":"43*A47","v":860},1.4359]
[24,{"$f":"43*A48","v":1032},1.4359]
[]
["Rear Wheel Weights","ranges defined on 8R tab"]
["72 kg"]
["None",0,0]
["One Pair",144,0]
["205 kg"]
["None",0,0]
["One Pair",410,0]
["Two Pairs",{"$f":"B56*2","v":820},0]
["Three Pairs",{"$f":"B56*3","v":1230},0]
["Four Pairs",{"$f":"B56*4","v":1640},0]
["Five Pairs",{"$f":"B56*5","v":2050},0]
["625 kg"]
["None",0,0]
["One Pair",1250,0]
["970 kg"]
["None",0,0]
["One Pair",1940,0]
[]
["Ballast packages"]
["None"]
[8935]
[8936]
[8937]
[]
["Front wheels"]
["G42"]
["290/90R38",410]
["320/85R38",440]
["600/65R28",500]
["380/85R34",406]
["420/90R30",354]
["480/70R30",420]
["540/65R30",460]
["600/65R28",500]
["G43"]
["320/80R42",510]
["380/80R38",512]
["420/85R34",520]
["480/70R34",580]
["540/65R34",580]
["600/70R30",530]
["IF600/70R30",588]
["G44"]
["380/80R42",618]
["420/85R38",560]
["620/75R30",700]
["IF620/75R30",679.46]
[]
["Rear wheels"]
["G47 single"]
["320/90R50",930]
["320/90R54",1060]
["380/80R46",870]
["380/90R50",990]
["420/80R46",920]
["480/80R46",1004]
["520/85R42",1070]
["620/70R42",1258]
["650/65R42",1220]
["710/70R38",1298]
["710/70R38HD",1382]
["G48 single"]
["380/90R54",1020]
["480/80R50",1100]
["520/85R46",1160]
["620/70R46",1220]
["650/85R38",1320]
["IF650/85R38",1379]
["710/70R42",1400]
["710/70R42HD",1406]
["IF710/70R42",1441.79]
["800/70R38",1571]
["G49 single"]
["480/95R50",1177.42]
["710/75R42",1435]
["IF710/75R42",1453.79]
["G47 dual"]
["None",0]
["320/90R50",780]
["320/90R54",930]
["380/80R46",740]
["380/90R50",890]
["420/80R46",790]
["480/80R46",880]
["520/85R42",980]
["620/70R42",1146]
["710/70R38",1172]
["710/70R38HD",1256]
["G48 dual"]
["None",0]
["380/90R54",920]
["480/80R50",910]
["520/85R46",1070]
["620/70R46",1130]
["650/85R38",1210]
["710/70R42",1328]
["710/70R42HD",1334]
["800/70R38",1459]
["G49 dual"]
["None",0]
["480/95R50",1074]
["710/75R42",1393]

{"sheet":"8R Option Weights","index":4,"n_rows":198,"n_cols":6,"rows_kept":198,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"kg total","% front axle","compatibility "]
["Model",null,null,"hp","PTO-hp","Weight if ILS"]
["8245R",0,0.47799999999999998,245,200,0]
["8270R",0,0.47799999999999998,270,225,0]
["8295R",22.7,0.47699999999999998,295,247,22.7]
["8320R",181.4,0.47799999999999998,320,269,181.4]
["8345R",181.4,0.48399999999999999,345,291,260.89999999999998]
["8370R",181.4,0.48399999999999999,370,313,260.89999999999998]
["8400R",181.4,0.48399999999999999,400,313,260.89999999999998]
[]
["Transmission","1300 MFWD",null,"1500 MFWD","ILS"]
["16 PST",303.18,0.47399999999999998,356.97,392.64]
["e23",0,0.501,0,0]
["IVT",341.36,0.45700000000000002,365.42,445.16]
[]
["Front Axle",null,"16 PST","e23","IVT"]
["1300 MFWD",8727.48,0.44900000000000001,0.47399999999999998,0.42799999999999999]
["1500 MFWD",9222.8700000000008,0.48,0.503,0.45600000000000002]
["ILS",9452.84,0.49399999999999999,0.51200000000000001,0.47399999999999998]
[]
["Front 3-Point Hitch"]
["Not Included",0,1.4845999999999999,null,"ILS wheelbase: 3050 "]
["Included",709.24474999999995,1.4845999999999999,"Requires ILS"]
[]
["Front PTO"]
["Not Included",0,1.4754,null,"assuming ILS: 3050"]
["Included",187.5,1.4754]
[]
["Fuel level","G47/48",null,"G49",null,"Diesel + DEF"]
["Empty",0,0.39,0,null,"G47/48: diesel volume of 645 L at .85kg/L"]
["Half",{"$f":"0.5*B34","v":288.06725},0.39,{"$f":"0.5*D34","v":305.49225000000001},null,"G49: diesel volume of 686 L at .85kg/L"]
["Full",{"$f":"(645*0.85)+(25.7*1.085)","v":576.1345},0.39,{"$f":"(686*0.85)+(25.7*1.085)","v":610.98450000000003},null,"def volume of 25.7 L at 1.085 kg/L"]
[]
["Front Weight Support"]
["Not Included",0,1.4701500000000001,null,"avg wheelbase: 3065"]
["Included",173,1.4701500000000001]
[]
["Front Suitcase Weights"]
["None",0,1.5629999999999999,null,"avg wheelbase: 3065"]
[4,{"$f":"43*A42","v":172},1.5629999999999999]
[8,{"$f":"43*A43","v":344},1.5629999999999999]
[12,516,1.5629999999999999]
[16,688,1.5629999999999999]
[22,{"$f":"43*A46","v":946},1.5629999999999999]
[]
["Rear Wheel Weights"]
["72 kg"]
["None",0,0]
["One pair",144,0]
["205 kg"]
["None",0,0]
["One pair",410,0]
["Two pairs",{"$f":"B54*2","v":820},0]
["Three pairs",{"$f":"B54*3","v":1230},0]
["Four pairs",{"$f":"B54*4","v":1640},0]
["Five pairs",{"$f":"B54*5","v":2050},0]
["625 kg"]
["None",0,0]
["One pair",1250,0]
["970 kg"]
["None",0,0]
["One pair",1940,0]
[]
["Ballast packages"]
["None"]
[8930]
[8931]
[8933]
[8932]
[8934]
[8938]
[]
["Front wheels"]
["G42 single"]
["320/85R38 ",440]
["380/85R34 ",406]
["420/90R30",354]
["480/70R30",420]
["600/65R28 ",500]
["G42 dual"]
["None",0]
["320/85R38",756.97]
["380/85R34 ",722.97]
["G43 single"]
["320/80R42 ",510]
["380/80R38",512]
["420/85R34 ",520]
["480/70R34 ",580]
["540/65R34",580]
["600/70R30",530]
["IF320/80R42",475.65]
["IF380/80R38 ",518.13]
["IF420/85R34",518.13]
["IF600/70R30 ",588]
["VF420/85R34",520]
["G43 dual"]
["None",0]
["320/80R42",826.97]
["380/80R38",828.97]
["420/85R34",836.97]
["480/70R34",896.97]
["IF320/80R42",792.61]
["IF380/80R38 ",835.09]
["IF420/85R34",835.09]
["G44 single"]
["380/80R42",570]
["420/85R38",560]
["540/75R34 ",568]
["600/65R34 ",636.37]
["620/75R30 ",728]
["650/60R34",704.69]
["IF620/75R30  ",730]
["IF650/60R34",710]
["G44 dual"]
["None",0]
["420/85R38 ",876.97]
[]
["Front group size"]
["Group 42"]
["Group 43"]
["Group 44"]
[]
["Rear group size"]
["Group 47"]
["Group 48"]
["Group 49"]
[]
["Rear wheels"]
["G47 single"]
["480/80R46",1004]
["520/85R42",1070]
["620/70R42",1258]
["650/65R42",1220]
["650/75R38",1292]
["710/70R38 ",1298]
["IF710/70R38 ",1369.75]
["G47 dual"]
["None",0]
["320/90R54",930]
["380/90R50",890]
["480/80R46",880]
["520/85R42",980]
["620/70R42",1146]
["710/70R38 ",1172]
["IF710/70R38 ",1261.4000000000001]
["G47 triple"]
["None",0]
["320/90R54",930]
["380/90R50 ",920]
["480/80R46",880]
["G48 single"]
["320/105R54",1160]
["380/90R54",1020]
["480/80R50",1100]
["520/85R46",1160]
["620/70R46",1220]
["650/85R38",1320]
["710/70R42",1400]
["800/70R38 ",1530]
["IF480/80R50 ",1304.33]
["IF650/85R38",1377.11]
["IF710/70R42",1647.25]
["IF800/70R38",1622.71]
["G48 dual"]
["None",0]
["320/105R54",1044]
["380/90R54",920]
["480/80R50",910]
["520/85R46",1070]
["620/70R46 ",1130]
["650/85R38 ",1210]
["710/70R42",1328]
["800/70R38",1410]
["IF480/80R50 ",1120.51]
["IF650/85R38 ",1291.8]
["IF710/70R42",1385.87]
["IF800/70R38",1514.36]
["VF480/80R50",1130]
["G48 triple"]
["None",0]
["320/105R54",1044]
["480/80R50",910]
["G49 single"]
["480/95R50 ",1266]
["710/75R42",1482]
["900/60R42",1749.32]
["IF480/95R50 ",1366.6]
["IF710/75R42 ",1457.51]
["IF900/60R42",1750]
["G49 dual"]
["None",0]
["480/95R50 ",1074]
["710/75R42 ",1390]
["IF480/95R50",1182.77]
["G49 triple"]
["None",0]

{"sheet":"8RT Option Weights","index":5,"n_rows":68,"n_cols":5,"rows_kept":68,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"kg total","% front axle","compatibility "]
["Model",null,null,"hp","PTO-hp"]
["8320RT",0,0,320,264]
["8345RT",0,0,345,286]
["8370RT",0,0,370,308]
[]
["Transmission"]
["e23",12410.52,0.71799999999999997]
["IVT",12752.52,0.72]
[]
["Fuel level","Diesel + DEF"]
["Empty",0,0.47499999999999998]
["Half",{"$f":"B16/2","v":337.34},0.47499999999999998,null,"diesel volume of 758L at .85kg/L"]
["Full",{"$f":"(758*0.85)+(28*1.085)","v":674.68},0.47499999999999998,null,"def volume of 28 L at 1.085 kg/L"]
[]
["Rear axle"]
["120 in",918.71,0,null,"medium, NA 90%"]
["160 in",1461.3,0,null,"NA only"]
[]
["Rear drive wheels"]
["Narrow",794.13,0]
["Wide",1259.73,0]
[]
["Tracks"]
["16 in, 4500 Series",{"$f":"368.3*2","v":736.6},0.5]
["16 in, 6500 Series",{"$f":"435.4*2","v":870.8},0.5]
["18 in, 4500 Series",{"$f":"372.9*2","v":745.8},0.5]
["18 in, 6500 Series",{"$f":"473*2","v":946},0.5]
["24 in, 4500 Series",{"$f":"487.6*2","v":975.2},0.5]
["25 in, 4500 Series",{"$f":"509*2","v":1018},0.5]
["25 in, 6500 Series",{"$f":"626*2","v":1252},0.5]
["30 in, 4500 Series",{"$f":"615.1*2","v":1230.2},0.5]
["30 in, 6500 Series",{"$f":"739*2","v":1478},0.5]
[]
["Front Weight Support"]
["Not Included",0,1.79165]
["Included",173,1.79165]
[]
["Front Suitcase Weights"]
["None",0,1.905]
[4,{"$f":"43*A43","v":172},1.905]
[8,{"$f":"43*A44","v":344},1.905]
[12,516,1.905]
[16,688,1.905]
[22,{"$f":"43*A47","v":946},1.905]
["22 + 10 side engine",{"$f":"43*32","v":1376},1.73]
[]
["Idler Weights"]
["36 kg"]
["None",0,1]
["One pair",72,1]
["Two pairs",144,1]
["72 kg"]
["None",0,1]
["One pair",144,1]
["Two pairs",{"$f":"144*2","v":288},1]
["Three pairs",{"$f":"144*3","v":432},1]
["Four pairs",{"$f":"144*4","v":576},1]
["Five pairs",{"$f":"144*5","v":720},1]
["Six pairs",{"$f":"144*6","v":864},1]
["Seven pairs",{"$f":"144*7","v":1008},1]
["Eight pairs",{"$f":"144*8","v":1152},1]
["205 kg"]
["None",0,1]
["One pair",410,1]
["Two pairs",{"$f":"410*2","v":820},1]